Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerAccountID (FK)(PK) | A unique identifier for a customer account. | ID_CTAC | Identity | integer | |
LayawayFeeAmount | A one time fee charged to administer a layaway account. | MO_LY_FE_AMT | Money | decimal(16,5) | |
LayawayMinimumPaymentAmount | A minimum monetary amount required to make a payment against the reserved merchandise. | MO_LY_MNM_PYM_AMT | Money | decimal(16,5) | |
LayawayMinimumPurchaseAmount | The minimum monetary value of a purchase required to set up a layaway account. For example a retailer may set up layaways only for purchases that exceed $20.00. | MO_LY_MNM_PCH_AMT | Money | decimal(16,5) | |
MinimumInitialPaymentAmount | The minimum monetary value required as a first payment to set up a layaway account. | MO_MNM_INT_PYM_AMT | Money | decimal(16,5) | |
MinimumInitialPaymentPercent | The minimum percentage of a purchase required as a first payment to set up a layaway account. | PE_MNM_INT_PYM | Percent | decimal(7,4) | |
RefundAllowedFlag | A boolean indicator that if YES means that a customer may cancel a layaway account (in effect a kind of return from layaway reserve inventory) and receive a refund possibley reduced by a cancellation fee. | FL_RFD_ALW | Flag | integer | |
LayawayCancellationFeeAmount | A flat fee charged by a retailer to cancel a layaway. The fee may be deducted from the money refunded to the customer. In a layaway the money refunded is the balance paid into the account by the customer. | MO_LY_CNCLLTN_FE_AMT | Money | decimal(16,5) | |
LayawayDefaultCancellationDate | The date this layaway account will be cancelled if it is not settled. This is a stop loss date. When a layaway purchase is not completed by this date, the account is cancelled, the merchandise is returned to inventory and a refund to the customer is issued (if possible) minus a layaway cancellation fee. For situations where a refund to the customer cannot be made, the account balance is transferred to a liability account where it is carried until it can be taken as income under the local escheatment laws. | DC_LY_DFLT_CNCLLTN_DT | DateCalendar | date | |